fe727cf1a08055fcb5cc75cc4d7eade198b9fc9f,bobas.businessobjectscommon.db.mysql/src/main/java/org/colorcoding/ibas/bobas/db/mysql/SqlScripts.java,SqlScripts,getBOTransactionNotificationScript,#String#String#number#String#String#,114
Before Change
@Override
public String getBOTransactionNotificationScript(String boCode, String type, int keyCount, String keyNames,
String keyValues) throws SqlScriptsException {
return String.format("CALL `%s_SP_TRANSACTION_NOTIFICATION`( N'%s', N'%s', %s, N'%s', N'%s')",
this.getCompanyId(), boCode, type, keyCount, keyNames, keyValues);
}
@Override
After Change
@Override
public String getBOTransactionNotificationScript(String boCode, String type, int keyCount, String keyNames,
String keyValues) throws SqlScriptsException {
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.append("CALL");
stringBuilder.append(" ");
stringBuilder.appendFormat("`%s_SP_TRANSACTION_NOTIFICATION`", this.getCompanyId());
stringBuilder.append("(");
stringBuilder.append(" ");
stringBuilder.append("N'");
stringBuilder.append(boCode);
stringBuilder.append("'");
stringBuilder.append(",");
stringBuilder.append(" ");
stringBuilder.append("N'");
stringBuilder.append(type);
stringBuilder.append("'");
stringBuilder.append(",");
stringBuilder.append(" ");
stringBuilder.append(keyCount);
stringBuilder.append(",");
stringBuilder.append(" ");
stringBuilder.append("N'");
stringBuilder.append(keyNames);
stringBuilder.append("'");
stringBuilder.append(",");
stringBuilder.append(" ");
stringBuilder.append("N'");
stringBuilder.append(keyValues);
stringBuilder.append("'");
stringBuilder.append(")");
return stringBuilder.toString();
}
@Override